{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Wells","3D Plot"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":92,"n_cols":23,"rows_kept":92,"cut":false,"hidden":false,"merged":[[15,0,35,0],[37,2,37,22]]}
["Construction Dewatering - Unconfined Aquifer"]
["Brigham Young University - CE En 544"]
[]
[]
[]
[]
[]
[]
[]
["k:",5.0000000000000001E-3,"[cm/s]",null,"xmin:",-50,"[m]",null,"Design h:",35,"[m]"]
["k:",{"$f":"B10/100","v":5.0000000000000002E-5},"[m/s]",null,"xmax:",150,"[m]",null,"Max h:",{"$f":"MAX(I23:K31,L26:P31)","v":35.395937541798375},"[m]"]
["H:",40,"[m]",null,"ymin:",-50,"[m]",null,"Total Q:",2.5999999999999999E-2,"[m^3/s]"]
["R:",500,"[m]",null,"ymax:",150,"[m]",null,null,{"$f":"totalQ*(3.28^3)*7.48*60","v":411.76338677759992},"[gal/min]"]
[]
[]
["Y",{"$f":"ymin+B72*(ymax-ymin)","v":150},{"$f":"sumwellh(C$37,$B16,k,H,RR, welltable)","v":37.24745513954214},37.148604224809958,37.055608236565078,36.971490220016783,36.899442027721811,36.842339103015377,36.80226140206787,36.780261156901979,36.776450763416278,36.79024028803623,{"$f":"sumwellh(M$37,$B16,k,H,RR, welltable)","v":36.820510176067728},36.865676718396315,36.923758052612321,36.992528059024352,37.069733726946524,37.153290928441109,37.241399631939039,37.332575002996606,37.425623684035912,37.519597567740362,37.613746114132219]
[null,140,37.113908687521445,36.999929261290163,36.891160257729673,36.791688484409697,36.706116628733128,36.638669331825945,36.592205889773531,36.567811591537911,36.565192719339954,36.583326098681731,36.620739866111904,36.675416831321158,36.744735039567246,36.825697440411282,36.915333207706077,37.011027216382786,37.110661541651936,37.212601475658666,37.315608844602373,37.418745369046299,37.521294227839419]
[null,130,36.977612018428673,36.845247530494106,36.716434631229255,36.596733661413545,36.4931309100118,36.412339738521659,36.358463595250207,36.33210118053379,36.331766394802187,36.355725715258366,36.402341218889866,36.469268358702962,36.552981722568951,36.649256716420894,36.754050246015311,36.864079551836532,36.976936542737178,37.090933441853693,37.204888441553457,37.317952563292557,37.429497651915398]
[null,120,36.840758885403126,36.686197531859115,36.531560913782805,36.384173791434911,36.255215412362141,36.156702935078364,36.095106856730141,36.068659684022208,36.072424149439975,36.103718286023323,36.161861773985414,36.244773215672154,36.347400399473003,36.463259979608686,36.586630072058981,36.713483896746297,36.841313127513551,36.96860742669778,37.094417868039336,37.218095333624291,37.339162761091686]
[null,110,36.707065968613122,36.526452791262493,36.338553196967034,36.151555244251576,35.983647042705755,35.860171186613186,35.79383122823468,35.773429734568083,35.783893344498544,35.822526863424791,35.894078868417566,35.998536459220134,36.127173031766731,36.268671201926814,36.414764462515507,36.561003584730464,36.70536805118666,36.846974093720142,36.985361492586151,37.120201237142744,37.251215830756294]
[null,100,36.582257105865502,36.373252900167216,36.144395298416725,35.89917532765292,35.6623449977834,35.497704135165748,35.443412475513597,35.447418259970483,35.466051195715401,35.504730889489082,35.589047553894083,35.725496350273467,35.89280346856161,36.068510634398422,36.241734557452197,36.409355983289039,36.571185015998424,36.727649110651683,36.879040613639262,37.025414067009926,37.166684586668737]
[null,90,36.473886166203577,36.238654450556524,35.96701411592305,35.643508208202768,35.263737246532017,34.992136517566756,35.038208850824709,35.112885201580632,35.128966715196078,35.1337089932886,35.222134011576557,35.419283883123164,35.649947307187773,35.870109376445122,36.073105001901951,36.26220646660262,36.441160301321972,36.61233332319852,36.77681875451654,36.934936339276248,37.086675933969232]
[null,80,36.389543470948716,36.137353382125404,35.837947411557238,35.454162732071211,34.861432429970598,33.796099108682348,34.683002704159399,34.845185378525393,34.811696453600561,34.662885862014974,34.714090732024935,35.087861060696561,35.420273673120406,35.687707371848369,35.916507444461409,36.123448819100837,36.317419522338746,36.502465437707684,36.679938329246681,36.849973492918075,37.012368802286495]
[null,70,36.333534080806423,36.07834006572584,35.781083468100654,35.418487987429756,34.957452402067887,34.587861442725874,34.689370764047432,34.742554356182239,34.628242617441458,34.182753224270542,33.976921641186117,34.847367343814909,35.251891535947877,35.539568457279344,35.778612139862631,35.995294904921742,36.200793487723175,36.398774285280084,36.589389852299178,36.771738834645539,36.945054655360437]
[null,60.000000000000014,36.304625893445532,36.057641434718107,35.783468613440796,35.482087095760228,35.176706270136101,34.950338835232245,34.855081585596281,34.793852472764378,34.67749664652375,34.490603406774888,34.516043953078785,34.863802161823969,35.177461832853453,35.432732543867509,35.659016894854474,35.875494459540384,36.089660660139138,36.300991523053504,36.505993625976046,36.701614439223903,36.886262500279159]
[null,50,{"$f":"sumwellh(C$37,$B26,k,H,RR, welltable)","v":36.297373642650314},36.062590040404714,35.81346652517383,35.558676303280549,35.319754386800511,35.129006293586023,34.999836983259293,34.907664181012251,34.825567022304313,34.769635141443601,{"$f":"sumwellh(M$37,$B26,k,H,RR, welltable)","v":34.812069906576454},34.967409789787773,35.159777274173756,35.350975637163643,35.545482547910176,35.754930581693152,35.979327051834254,36.208229028038176,36.430974554299013,36.641567896076516,36.837978983106453]
[null,40,36.305585040520796,36.081208857447898,35.849491469008917,35.62030611319112,35.409770184787263,35.235752511744508,35.106955301697027,35.017999123863838,34.960713317641016,34.939553544624857,34.968850833942881,35.046352335012166,35.149108714240306,35.265457765872895,35.412850547918332,35.615579531464206,35.862880002954313,36.120893826703906,36.367344695167581,36.594826022283918,36.80288755612623]
[null,29.999999999999801,36.324928645199215,36.10657374648293,35.882606670023712,35.662346675634069,35.460340107605198,35.293451434145197,35.173108410556722,35.098859499299479,35.062040763953803,35.054872554898964,35.071768924487763,35.102337194369341,35.130405008013277,35.150769439426064,35.214674793198853,35.425005403540155,35.736729629516361,36.045714132310877,36.32206386951794,36.566468571988658,36.784391976537265]
[null,19.999999999999801,36.353860359501311,36.136919885144763,35.911534078350513,35.685352718032213,35.47384244149972,35.301609462479661,35.191276560667298,35.142554117066361,35.134194733131807,35.144809117899769,35.159258042280435,35.161790809209911,35.12760132248706,35.013961460756668,34.819796387130495,35.13003855563457,35.626017957564294,36.004222240043532,36.307228836383281,36.562985149625938,36.786061507837353]
[null,9.999999999999801,36.393523451642082,36.175004197633825,35.941074371211336,35.694129104621901,35.447213783862978,35.242448073509259,35.143420673005785,35.146587236955398,35.188664444959443,35.23054795720526,35.256907460831577,35.254883004768324,35.199464880733366,35.024174501256759,34.43417573807271,35.003742449036615,35.633908359532846,36.030523975301108,36.335580348826021,36.589730271332712,36.81035604989156]
[null,-1.9895196601282805E-13,36.44697989501541,36.227368314345533,35.983349839950456,35.705848932743237,35.384817289638356,35.060567912306986,34.980587496495851,35.119788031274368,35.24697412431621,35.331645593975502,35.380765723622986,35.395937541798375,35.370719291185509,35.298158148565832,35.243269843712611,35.451009726077849,35.810873090653637,36.134959916132054,36.409735614309525,36.647293915934114,36.85724722179036]
[null,-10.000000000000199,36.517624212162183,36.301973075389078,36.056444301449659,35.761354200978815,35.36392774995015,34.634663195176742,34.644119017700426,35.138219611201627,35.348884291734187,35.466438921153312,35.536563885698385,35.575688858487943,35.59318490048188,35.606584667606015,35.661929691828547,35.813858426379589,36.042162345078609,36.286855927426679,36.518415830306402,36.730450644954985,36.923876823426276]
[null,-20.000000000000203,36.607035073883971,36.403367358390319,36.172890631479866,35.900448738574084,35.555597663559361,35.119270934786087,35.072830584644471,35.348356640497165,35.529305112375162,35.644042427397814,35.721379606518205,35.777048474264895,35.823475723002936,35.876978588764217,35.960193036046405,36.090384632021113,36.261890333891721,36.453079788383974,36.645807714616396,36.831028270208051,37.005612554641701]
[null,-30.000000000000199,36.713568274903125,36.528878368192174,36.326733615902867,36.104190160020465,35.866931151715583,35.662864775530288,35.600287324400469,35.671179546253974,35.769833248212784,35.855705952476484,35.926198212853691,35.987119262249486,36.046702857971717,36.115343713385499,36.204177621914198,36.320088004548317,36.460973802732902,36.617675712198718,36.780193623908637,36.941458011164549,37.097589950045496]
[null,-40.000000000000199,36.832865860182608,36.670285600606121,36.499819786002384,36.325406261751205,36.159854615493167,36.031463623663917,35.972218350785035,35.980906348134191,36.02596189911354,36.082096461815304,36.13955726528792,36.197608837228131,36.259711175565045,36.331248396916983,36.417599778349668,36.521740944125462,36.64258754118768,36.775622299976149,36.915170516840099,37.056339758282462,37.195735314017362]
[null,-50,36.95967828335813,36.818711932851656,36.676534535829347,36.538569003854818,36.414970350322314,36.320287106919416,36.266718054905205,36.254397247891454,36.272046503688301,36.307031014257724,36.351609425656882,36.403077230560129,36.46200413253046,36.530570271605271,36.61109172173294,36.70469559865419,36.81055183136111,36.926061375487166,37.0477701494885,37.17233164305383,37.297061129844309]
[null,null,{"$f":"xmin+C72*(xmax-xmin)","v":-50},-40,-30,-20,-10,0,10,20,30,40,50,60.000000000000014,70,80,90,100,110,120,130,140,150]
[null,null,"X"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,0.95]
[null,0.9]
[null,0.85]
[null,0.8]
[null,0.75]
[null,0.7]
[null,0.65]
[null,0.6]
[null,0.55000000000000004]
[null,0.5]
[null,0.45]
[null,0.39999999999999902]
[null,0.34999999999999898]
[null,0.29999999999999899]
[null,0.249999999999999]
[null,0.19999999999999901]
[null,0.149999999999999]
[null,9.9999999999999006E-2]
[null,4.9999999999998997E-2]
[null,0]

{"sheet":"Wells","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Wells"]
[]
["#","x","y","Q [m^3/s]"]
[1,-1.3677811550151944,78.605297139726162,{"$f":"totalQ/4","v":6.4999999999999997E-3}]
[2,4.5086119554204629,-12.17484470424548,{"$f":"totalQ/4","v":6.4999999999999997E-3}]
[3,46.251266464032426,70.094658841853814,{"$f":"totalQ/4","v":6.4999999999999997E-3}]
[4,92.857142857142861,12.411443711830181,{"$f":"totalQ/4","v":6.4999999999999997E-3}]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]

{"sheet":"3D Plot","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}